How to: Save filter as a query.
Solution:
Display the filter in the 'Filter By Form' or 'Advanced Filter/Sort' window, and save the filter.
1) If the Database window is not active, activate the Database window.
2) Go to the Table Datasheet view or the Form view>.
3) Select the 'Records' menu and select 'Filter'. (A submenu appears.)
4) Select 'Filter By Form' or 'Advance Filter/Sort' from the 'Filter' submenu. (The appropriate filter window appears.)
5) Make the desired selections and entries.
6) Select the 'Filter' menu and select 'Apply Filter/Sort'.
7) Select the 'File' menu and select 'Save As Query...'. (The Save As Query dialog box appears.)
8) Type a name for the query in the 'Query Name' box.
Query Name box
9) Click 'OK'. (The new query appears in the Database window when the Queries tab is chosen.)
